//
//  ZQTableHelper.m
//  ZQSmartLife
//
//  Created by huanghuan on 15/6/10.
//  Copyright (c) 2015年 huanghuan. All rights reserved.
//

#import "ZQTableHelper.h"

@implementation ZQTableHelper
#pragma -mark 设备表
+(NSString *) createDeviceTab
{
    NSString *sql = @"CREATE TABLE IF NOT EXISTS device (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, devicetype INTEGER NOT NULL, rctype TEXT NOT NULL, ver INTEGER,addr TEXT NOT NULL, icon TEXT,roomId TEXT,systemId TEXT, visible INTEGER,  orders INTEGER NOT NULL)";
    return sql;
}

+(NSString *) clearDeviceTab
{
    NSString *sql = @"delete from device";
    return sql;
}
@end
